package com.ccjt.eip.web.mybatis.dao;

import com.ccjt.eip.web.mybatis.po.InformationSchema;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;

@Mapper
public interface CodeFactoryDao {

    @Select("select table_name from information_schema.tables where table_schema='sg' and table_type='base table'")
    List<String> getTableName();

    @Select("select column_name,data_type,column_comment from information_schema.columns where table_schema=#{table_schema} and table_name=#{table_name}")
    List<InformationSchema> getColumnName(@Param("table_schema") String table_schema, @Param("table_name") String table_name);

}
